package com.example.jw_web.Mapper;

import com.example.jw_web.pojo.Works;
import com.example.jw_web.pojo.activeDao;
import com.example.jw_web.pojo.introduce;
import com.example.jw_web.pojo.member;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Mapper
@Component
public interface HomePageDao {


    @Select("select * from active")
    List<activeDao> getitems();

    @Select("select * from member")
    List<member> getMembers();

    @Select("select * from works")
    List<Works> getWorks();

    @Select("select  * from introduce")
    List<introduce> getintroduces();

    @Select("select * from works where sort=#{sort}")
    List<Works> getSortWorks(String sort);

    @Select("select * from works where title like CONCAT('%', #{title}, '%')")
    List<Works> getresearchworks(String title);

   List<member> getMembersByJobAndTime(List<String> jobs,List<String> times);


}
